package com.hos.db.create.visit;

/**
 * 随访
 * Created by guom on 2018/10/15.
 */
public class VisitTable {
    public static String tableName = "pat_visit";
    public static String tableVisitId = "visit_id";// id
    public static String tablePatId = "pat_id";//患者id
    public static String tableDocId = "doc_id";//医生id
    public static String tableVisitMsg = "visit_msg";//  详情
    public static String tableVisitState = "visit_state";// 状态
    public static String tableVisitInspectTime = "visit_inspect_time";// 检查时间
    public static String tableVisitReviewTime = "visit_review_time";// 复查时间

    public static String tableVisitCreateTime = "visit_create_time";//  创建时间
    public static String tableVisitUpdateTime = "visit_update_time";//  修改时间

    //
    public static String careteTable = "create table  "
            + tableName + " ( "
            + tableVisitId + "  varchar(200) primary key, "//主键
            + tablePatId + " varchar(200), "
            + tableDocId + " varchar(200), "
            + tableVisitMsg + " longText,"
            + tableVisitState + " int, "
            + tableVisitInspectTime + " datetime, "
            + tableVisitReviewTime + " datetime, "
            + tableVisitCreateTime + " datetime, "
            + tableVisitUpdateTime + " datetime "
            + "); ";

}
